Database Quiz

To add a series of cells with numbers, use the function...

• SUM

• PLUS

• ADDITION

• =

To remove the Gridlines in Excel...

• Remove Gridlines

• Click View, click Gridlines

• Click Gridlines, click Remove

• Click View, Click Remove

The formulas that you create in Excel appear in the...

• Status bar

• Title Bar

• Screen

• Formula Bar

To save the Workbook you are currently working on, press...

• Ctrl B

• Ctrl S

• Alt F4

• Ctrl W

To get 35% of the total in cell A1, the formula is...

• =A1 * 0.35

• =SUM(A1*100)/.35

• =A1 / 35

• =A1+35

Mixing numbers with letters in computation will result to...

• an error

• a positive result

• a negative result

• alpha numeric

To add all numerical contents from B1 to B10, the formula is...

• =B1+B10

• =SUM(B1:B10/100)

• =SUM(B1:B10)

• None of these

To edit a formula with an error...

• double-click on the cell

• delete the formula

• make a new formula

• None of these

To copy the content of a cell, the shortcut key is...

• Ctrl V

• Ctrl C

• Ctrl S

• Ctrl P

The shortcut key to Paste a copied cell or content, the shortcut key is...

• Alft F4

• Ctrl S

• Ctrl C

• Ctrl V