Font size
WorksheetsQUIZ
Total questions: 60
Worksheet time: 40mins
refers to the space between the edge of the printed page and the content within the cells.
(a)
refers to the direction in which a worksheet is printed. You can choose between 'Portrait' (vertical) and 'Landscape' (horizontal) orientations.
(a)
refers to a specific range of cells that you designate to be printed.
(a)
This command will help you choose an image to be used as the background of the sheet.
(a)
refers to the setting that allows you to see the gridlines on your worksheet while working.
(a)
in Excel refers to the action of moving an object, such as a shape or an image, closer to the front layer of other objects.
(a)
in Excel is a tool that helps you manage and organize objects, such as shapes, charts, and images, in your worksheet.
(a)
refers to the ability to change the orientation of text or objects (like shapes or images) within a cell or on the worksheet.
(a)
What is the purpose of the Page Setup Options in Excel?
To change the font style
To insert new rows
To customize printing settings
To calculate formulas
How can you adjust the Margins in Excel?
Access the View tab -> Page Layout -> Customize margins
Navigate to Home tab -> Page Setup -> Modify margins
Go to Insert tab -> Margins -> Adjust margin size
Go to Page Layout tab -> Margins -> Select desired margin option
Explain the difference between Portrait and Landscape Orientation in Excel.
Portrait orientation is used for printing documents, while landscape orientation is used for viewing documents.
Portrait orientation has a taller appearance, while landscape orientation has a wider appearance.
Portrait orientation is used for landscape photos, while landscape orientation is used for portrait photos.
Portrait orientation is wider, while landscape orientation is taller.
What are Themes and Colors used for in Excel?
Themes are used to insert images in Excel
Themes are used to create animations in Excel
Themes are used to apply a consistent set of fonts, colors, and effects across the entire workbook, while Colors are used to highlight specific data points or elements within the spreadsheet.
Colors are used to change the language settings in Excel
How can you add Backgrounds and Watermarks to an Excel sheet?
Access 'Review' tab and click on 'Add Background' or 'Add Watermark'
Right-click on the sheet and choose 'Insert Background' or 'Insert Watermark'
Go to 'Data' tab and select 'Background' or 'Watermark' option
Navigate to 'Page Layout' tab, select 'Background' or 'Watermark' in 'Page Setup' group, choose image or text, adjust settings, and click 'OK'.
What is the significance of Paper Size in Excel?
Paper size in Excel determines the font size of the data
Paper size in Excel is important for printing purposes to ensure proper formatting and layout of the data on the printed page.
Paper size in Excel affects the color scheme of the spreadsheet
Paper size in Excel determines the number of rows and columns in a worksheet
How can you set the Print Area in Excel?
Click on the Home tab and select Print Area
Use the Insert tab to set the Print Area
Select cells, go to Page Layout tab, click Print Area, select Set Print Area
Right-click on the cells and choose Set Print Area
What does Height and Width refer to in Excel?
Number of worksheets in a workbook
Number of rows and columns in a worksheet
Number of cells in a worksheet
Number of charts in a worksheet
Explain the process of adding a Watermark to an Excel sheet.
Clicking on the 'Insert' tab and selecting 'Watermark'
Accessing the 'Review' tab and choosing 'Watermark' from the dropdown menu
The process involves navigating to the 'Page Layout' tab, selecting 'Watermark' in the 'Page Setup' group, choosing a watermark option, and customizing the settings.
Opening the 'Data' tab and clicking on 'Watermark' in the 'Data Tools' group
Page set up:
Formula Auditing:
A user can customize a worksheet’s layout and add effects to the worksheet using this menu
Page layout Menu
The Formulas Menu
The File Menu
The Home Menu
Assigns a unique set of colors, fonts, and effects to each style.
Font
Theme
Styles
Cells
It is one of the main menu in Ms Excel that allows users to performed mathematical calculations based on formulas and numbers in other cells
File Menu
Home Menu
Formula Menu
Page Layout Menu
Allows the user to create formulas from different categories like a statistic, trigonometry, logical, and financial.
Function Library
Formula Auditing
Caculation
Number
Adjusts row height, column width, and scaling.
Number
Alignment
Font
Scale
It displays
the worksheet, as it would look when printed. It also displays all headers
and footers in the document. Headers and footers are editable in this view.
Page Layout view
Print Layout view
Page Break view
Print Break view
This view gives you the opportunity to view horizontal
and vertical page breaks in the document, and allows you to adjust these
page breaks to fit information onto a worksheet. It also identifies each page
number by placing a watermark on each page in the workbook to guide
you.
Print Break view
Page Layout view
Page Break view
Print Layout view
We always print Excel documents how?
Portrait orientation
Excel orientation
Landscape orientation
Full orientation
Excel will calculate your totals using what function?
ADD
MAX
MIN
SUM
The theme of an Excel document is changed under which tab?
Home
Insert
Page Layout
Formulas
These two rows have $ signs using what command?
Accounting Number Format
Comma Style
Number Style
Percent Style
If you get a chart that looks like this, what did you not do?
Select a range
Pick the right chart
Entered data incorrectly
Didn't use SUM function correctly
What does the equals sign (=) signify in an Excel formula?
The cell contains the formula and its value
The start of a subtraction
The formula must be equal to the following value
The end of a formula
It is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and allow you to create and view formulas.
Active Cell
Formula Bar
Command Buttons
Ribbon Group
Which symbol must you use to begin a formula ?
$
#
@
=
This is an example of a ?
formula
sum formula
cell address
Which of the following shows the accurate formula to determine the total budget?
=1+2
=B3
=A1+A2
=B1+B2
What cell contains an Excel formula?
A4
B4
C4
D4
What cell contains the word Excel?
A4
B4
C4
D4
What cell contains a combination of text and numerical data?
A1
A4
B2
D4
what is the Annual Withholding Tax of an employee having a monthly salary of 12 thousand.
10,000
0
10
1,000
How much is your monthly contribution in the Philhealth Insurance Company if your monthly salary base is 20 thousand?
20,000
700
350
0
As a private employee, you were deducted by your payroll in-charge for the month of October an amount of 135.00 as your mandatory remittance. How much is your salary bracket?
5, 000
300
3,000
20,000
Which of the following is not a valid data type in Excel?
Character
Label
Date/Time
Number
Mr. ICT salary is 15,000 thousand monthly and a night differential of 500 plus over time of 1,300 for the month of December 2021. How much total deduction were you able to deduct for the month considering with all government mandatory deductions is applied. (like sss, philhealth, pag ibig, withholding tax and Cash advance of 300?) Solve the problem.
500
15,000
1.695
1300
Which function inserts a date that updates when the worksheet is recalculated or opened?
VLOOKUP
TODAY()
COUNTIF
NOW()
Which function searches a value in the leftmost column of a table and then returns a value in the same row from a specified column?
SUMIF
COUNTIFS
VLOOKUP
AVERAGEIF
Which function adds the values in cells specified by a given condition or criteria?
SUMIFS
NOW()
AVERAGEIF
COUNTIF
What does the SUMIF function do?
Finds the average for the cells specified by a given condition or criteria
Adds the values in cells specified by a given set of conditions or criteria
Counts the number of cells within a range that meet the given condition
Inserts a date that updates when the worksheet is recalculated or opened
What does the NOW() function do?
Inserts a date that updates when the worksheet is recalculated or opened
Inserts the date and time that update when the worksheet is recalculated or opened
Returns the middle number in a sorted list of numbers
Adds the values in cells specified by a given condition or criteria
Which term represents a named operation that replaces the arithmetic expression in a formula?
Reference
Constant
Function
Operator
What do you call a cell or a range of cells on a worksheet with value(s)?
Operator
Function
Reference
Constant
What is a special character that specifies the type of calculation in a formula?
Constant
Reference
Operator
Function
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Filtering
Pivot
Which one is not a Function in MS Excel?
SUM
AVG
MAX
MIN
formulas are mathematical statements used to calculate values
True
False
When pasting a range of cells, any existing cell contents at the new location are automatically moved to make room for the pasted data
True
False
The auto calculate feature
can only add values in a range of cells
provides a quick way to view the result of an arithmetic operation on a range of cells
automatically creates formulas and adds them to a worksheet
a and c
Which of the following formulas is not entered correctly?
=10+50
=B7*B1
=B7+14
10+50
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
A financial analyst wants to sensitize the gross profit of a company using two major inputs: gross margin (horizontal inputs) and sales growth percentage (vertical inputs). Given the screenshot below, what values should be entered for the row input cell and column input cell to generate the data table?*
Row input cell: B11; column input cell: A12
Row input cell: A12; column input cell: B11
Row input cell: B3; column input cell: B2
Row input cell: B2; column input cell: B3
