Empowerment Technologies Quiz

Which symbol must all formula begin with?

• =

• +

• (

• @

Which of the following extensions is applied to a data source you create in Word?

• .docx

• .mdb

• .xlsx

• .dotx

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

• Formula

• Field

• Data

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

• G1-G10

• B1.G10

• B1;G10

• B1:G10

Which of the following formulas is not entered correctly?

• =10+50

• =B7*B1

• =B7+14

• 10+50

Which of the following formulas will Excel Not be able to calculate?

• =SUM (A1:A5) - 5

• =SUM(A1: A5)+ 5

• =SUM(A1;A5)/(10-10)

• =SUM(A1:A5)-10

An excel keyboard shortcut command to cut.

• Ctrl + C

• Ctrl + U

• Ctrl + x

• Ctrl + Y

Keyboard shortcut in MS Excel to open Format Cells dialog box

• Ctrl + F

• Shift + F

• Ctrl + Shift + F

• Alt + Shift + F

MS PowerPoint and MS Excel keyboard shortcut keys to replace text/word.

• Ctrl + R

• Ctrl + E

• Ctrl + H

• Ctrl + F

MS PowerPoint and MS Excel keyboard shortcut keys to find text/word.

• Ctrl + R

• Ctrl + E

• Ctrl + H

• Ctrl + F