How many worksheets can a workbook have?
3
8
255
None of the above
Correct answer is D
Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.
What is the correct way to refer to cell A10 on sheet3 from sheet1?
Sheet3!A10
Sheet1!A10
Sheet3.A10
A10
Correct answer is A
No explanation has been provided for this answer.
Which of the following Charts can be created in Excel?
Area
Line
Pie
All of the above
Correct answer is D
Excel offers the following major chart types:
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________
AutoFill
Auto correct
Auto sum
Auto format
Correct answer is C
AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.
An Excel Workbook is a collection of ________
Workbooks
Worksheets
Charts
Worksheets and Charts
Correct answer is D
A workbook is a collection of one or more spreadsheets and charts in a single file.
Zonal Administrative Assistant at World Health Organization (WHO)
Officer - Payroll at MTN Nigeria
Supervisor - Warehouse at MTN Nigeria
Customer Services Representative at Tetra Pak
Community Engagement and Monitoring Assistant at World Health Organization (WHO)
Customer Service Representative at Eric Kayser
Training Manager at United Nigeria Airlines
Financial Controller at United Nigeria Airlines
Data Entry Clerk at Jolly Energy Fleet Limited