Advance Productivity Tool using Excel

What computer application gives the user the ability to do calculations, create tables and can edit values?

• Microsoft Word

• Microsoft Excel

• Microsoft OneNote

• Microsoft PowerPoint

What is the formula that will add the data of cells A1 to A10?

• =SUM(A1:A10)

• =AVE(A1:A10)

• SUM(A1:A10)

• =A1+10

Teacher Mark wants to input an equation to his spreadsheet to calculate the grades of his student, where should he enter the equation?

• EXCEL FORMULA

• EQUATION BAR

• FORMULA BAR

• ALL OF THESE ARE CORRECT

Let cell A1=95, B1=88, C1=90. What is the output of the equation =SUM(A1:A3)/3

• 100

• 88

• 101

• 91

A formula always starts with an _______.

• Equal sign

• Additional sign

• Multiplication sign

• Division sign

Keep in mind that spreadsheet applications such as Microsoft Excel and Google Sheets can automatically store, organize, analyze, and interpret large amounts or groups of data.

• True
• False

• Maybe

• None of these makesense

Ctrl + X is the shortcut key for?

• Copy

• Paste

• Cut

• Undo

What is the shortcut key for Center Alignment?

• Ctrl+R

• Ctrl+E

• Ctrl+C

• Ctrl+A

How many rows in excel?

• 2,048,576 rows

• 1,048,576 rows

• 10,000 rows

• 1,048 rows

What is the last column letters in excel

• XFD

• ZZZ

• ABC

• Z