Question 1

1. What is the quickest way to find the sum of numbers in cells B4 to B8?

Accepted Answer

D. Highlight cells B4 to B8

Answer

B. Use the SUMIF formula.

Answer

C. Use the SUMIFS formula.

Answer

A. Use the SUM formula.

Question 2

2. What are the TWO ways to change the number for Final Fantasy 15 game, from 29 to 29.97 without having to retype the entire number?

Accepted Answer

D. Both A and B are correct.

Answer

A. Click Cell C3 and click in the Formula bar and change.

Answer

B. Double-click the Cell C3 and change the number.

Answer

C. Click the number in Cell C3 and type the number.

Question 3

3. How would you center the text, "Game Zoners Pte Ltd", in between cells B2 to E2?

Accepted Answer

A. Highlight Cells B2 to E2 and click Merge and Center icon.

Answer

C. Click and drag Cell B2 till the text is in the center of B2 and E2.

Answer

D. Not possible to center the text between B2 to E2.

Answer

B. Highlight cell B2 and click Center Alignment icon.

Question 4

4. What are the TWO ways to enter the value of Unit Price in cell C4, from the Games Database in Cell D13?

Accepted Answer

D. Both B and C are correct.

Answer

C. Click on Cell D13, press Ctrl C, click on Cell C4 and press Ctrl V.

Answer

A. Click on Cell C4 and type the value of the Unit Price.

Answer

B. Click on Cell C4, type '=' symbol, click on Cell D13 and press Enter.

Question 5

5. Which of the following is the correct formula to calculate the Total Price in Cell E4?

Accepted Answer

D. =C4*D4

Answer

B. =C5*D5

Answer

A. =AVERAGE(E5:E8)

Answer

C. =SUM(E5:E8)

Question 6

6. Which of the following is the correct steps to find the Total Sales for Playstation in Cell C4?

Accepted Answer

B. Click on Category, Filter launch button, unselect 'Select All' box, select 'Playstation' Box and highlight the Total Price cells.

Answer

C. Enter the formula '=SUM(D10:D19)

Answer

D. Enter the formula '=COUNTIF(D10:D19,"Playstation")

Answer

A. Calculate all the Total Price for Playstation using calculator and enter value in Cell C4.

Related quizzes