Excel computer test - Part 2

If you are still interested in the multiple choice questions we send, continue with part 2 of our Excel computer quiz right below. Each question will have 4 options to choose from, challenge yourself and learn interesting things.

Question 1 . In the Excel spreadsheet, to edit the data in a cell without re-entering it, we do:

A. Click to select the cell to fix, then press F2.
B. Click to select the cell to fix, then press F4.
C. Click to select the cell to fix, then press F10.
D. Click to select the cell to fix, then press F12.

Question 2 . To prepare to print an Excel spreadsheet to paper?

A. Excel must have a page number in the right position at the top of each page.
B. Can print the page number or not.
C. Only type the number of printed pages if the spreadsheet is multi-page.
D. The position of the page number is always in the lower right corner.

Question 3 . In the Excel worksheet, in cell A2, there is a string of characters "1Angiang2" available. If using the fill button to enter data to columns B2, C2, D2, and E2, the result obtained in cell E2 is:

A. 1Angiang6
B. 5Angiang6
C. 5Angiang2
D. 1Angiang2

Question 4 . In Excel spreadsheet, delivery of a row and a column is called?

A. Data.
B. Oh.
C. School.
D. Recipe.

Question 5 . In the Excel worksheet, in cell A2, the data is the "Tin hoc van phong" character set, in cell B2, enter the formula = PROPER (A2) and get the result?

A. Tin hoc van phong
B. Information technology
C. NEWS HOC VAN PHONG
D. Tin Hoc Van Phong

Question 6 . In Excel, in cell A2 the value is 10; cell B2 has a value of 3. In cell C2 type the formula = MOD (A2, B2) then get the result:

A. 10
B. 3
C. #Value
D. 1

Question 7 . Assuming the computer's system date is: 8/18/2008, then in cell A2 type in the formula = Today () - 1, the result is:

A. 0
B. #VALUE!
C. #NAME!
D. 8/17/2008

Question 8 . In Excel spreadsheet, in cell D2 there is a formula = B2 * C2 / 100. If the formula is copied to cell G6, the formula is:

A. E7 * F7 / 100
B. B6 * C6 / 100
C. E6 * F6 / 100
D. E2 * C2 / 100

Question 9 . In the Excel worksheet, in cell A2, the data is the "Tin hoc van phong" character set, in cell B2, enter the formula = LOWER (A2), the result is obtained?

A. TIN HOC VAN PHONG
B. Tin hoc van phong
C. tin hoc van phong
D. Tin Hoc Van Phong

Question 10 . In the Excel spreadsheet, in cell A2, the number 10 is available; in cell B2, type in formula = PRODUCT (A2.5), then get the result:

A. #VALUE!
B. 2
C. 10
D. 50

Answer:

See more:

1. How to activate Microsoft Office 2016 Professional Plus for free
2. Instructions on how to set a password to protect the Excel file safely
3. These are the most basic functions in Excel that you need to understand