Font size
WorksheetsSpreadsheet(Advanced Mixed Quiz)
Total questions: 24
Worksheet time: 13mins
Which feature of Calc helps to see the changes made in the shared worksheet?
Solver
Subtotal
Record Changes
None
We can add a comment regarding any changes made in shared worksheet by:
Edit > Changes > Comments
File > Changes > Comments
View > Changes > Comments
None
Which button is pressed to accept every change that has been made in the worksheet?
Accept
Accept all
Accept Changes
Accepted
What is the purpose of accepting/rejecting changes in a shared spreadsheet?
To print the spreadsheet
To undo the changes made
To share the spreadsheet with others
To apply the changes permanently
To select random multiple cell hold down ......... key as click on each cell.
Alt
Shift
Ctrl
All of the above
Which of the following is more elaborate form of Goal Seek?
Scenario
SUbtotal
Solver
All
If you have two spreadsheets in the same folder linked to each other and u move the entire folder to a new location, a relative hyperlink will
A (a) tool provides a target based result and informs the user about the changes in value in the applied formula.
Which of the following functions are available in consolidate window?
MAX
MIN
COUNT
ALL OF THE ABOVE
Scenarios are tools to test ....... questions.
if else
what else
what if
if
Hyperlink in Calc can be used to jump from from
one sheet to another
one sheet to website
one section to another section of same sheet
all of the above
the data consolidation function takes data from a series of worksheets or workbook and summaries it into a (a) ?
Which function calculates the average of a given set of numbers?
SUM()
Average()
AVG()
All
What does the Goal Seek tool do?
allows you to see how changing one data item in a formula affects the others
automatically sorts or totals data
highlights the major functions and outcomes of your data set
allows you to add values in a selection of cells
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
What does every formula in MS EXCEL start with?
+
-
=
*
When is a MS Excel Spreadsheet used?
Making a Drawing
When Reading
For Collecting Information
For Baking a Cake
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.
A) AutoSum
B) Custom Fill
C)Fill Handle
D)Ctrl+C
The two options to do the reverse calculation process
Scenario manager and Goal seek
Goal seek and Solver
Solver and Data table
Data table and Scenario manager
The process of reverse calculation to achieve a desired result by using multiple variables.
Goal seek
Data Table
What-if-analysis
Solver
Which tool creates scenario with a set of values that Excel saves without changing the actual values.
Data Table
Goal seek
Scenario manager
Solver
The process of reverse calculation to achieve a desired result by using a single variable and a single cell.
Scenario manager
Solver
Data Table
Goal Seek
_____________ analysis is done on a range of cells that displays how changing one or two variables affects the results.
Solver
Data Table
Goal seek
Sub total
