EED QUIZ #1F

FILE MENU OPTIONS IN THE CURRENT PROGRAM.

• CTRL + F

• ALT + F

• TAB + F

• SHIFT + F

FORMULA IN EXCEL STARTS WITH __________.

• *

• _

• ?

• =

IF CELLS A1 AND A2 ARE EMPTY, WHAT WILL BE THE VALUE OF THE FOLLOWING EXCEL FORMULA ? =A1 + A2

• 0

• 3

• NAME ? ERROR

• VALUE! ERROR

WHICH OF THE FOLLOWING IS NOT A VALID FUNCTION IN MS EXCEL?

• SUM()

• COUNT()

• COUNTA()

• SUBTRACT()

WHICH OF FOLLOWING IS THE SHORTCUT KEY TO OPEN A NEW BLANK DOCUMENT IN MS WORD

• CTRL + B

• CTRL + N

• CTRL + D

• CTRL + M

EACH TABLE APPEARS AS A SPREADSHEET GRID CALLED

• QUERIES

• TABLE

• DATASHEET

• RECORD

IN MS EXCEL, TO ADD NUMERIC VALUES IN COLUMN D, FROM ROWS D10 TO D15, THE FORMULA THAT SHOULD BE USED IS.

• =SUM(D10,D15)

• =COUNT(D10,15)

• =SUM(D10:D15)

• OPIONS 1 AND 3 ARE CORRECT

The intersection of a row and a column is called a ________.

• cell

• chart

• sum

• worksheet

A group of cells is called a ________.

• multicell

• cell cluster

• cell range

• chart

You can click the tabs at the bottom of a workbook to switch between ________.

• number formats

• formulas

• permissions

• worksheets