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:
- Column Chart
- Line Chart
- Pie Chart
- Doughnut Chart
- Bar Chart
- Area Chart
- XY (Scatter) Chart
- Bubble Chart
- Stock Chart
- Surface Chart
- Radar Chart
- Combo Chart
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.
Aptitude Tests
Latest Jobs
Indorama Eleme Fertilizer & Chemicals Limited (IEFCL) Graduate Engineer Internship Program 2024
Diploma Engineer Internship Program at Indorama Eleme Fertilizer & Chemicals Limited (IEFCL)
Admin Officer - Airline Industry at Ascentech Services Limited
Area Sales Manager at Airtel Nigeria
State Business Manager at Airtel Nigeria
Inventory Manager at a Reputable Agricultural Company
Supply Chain Officer at Kellogg's Tolaram Nigeria Limited (KTNL)
Warehouse Manager at Shulifang Biotechnology FZE
Capability Development & Execution Excellence Manager (Rivers) at Airtel Nigeria
Regional Security Manager - Northeast Region at Airtel Nigeria
