NEW
Font size
WorksheetsDIT EOC
Total questions: 75
Worksheet time: 40mins
Pre-designed and formatted files called ______ help to create new worksheets quickly.
Documents
Templates
Folders
Cell Reference
The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.
Document
Presentaion
Publicaiton
Worksheet
This area tells you the name of the project and the name of the program you have open.
Status Bar
Formula Bar
Title Bar
Quick Access Toolbar
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
The intersection of a column and a row is called a __________.
Four-way Stop
Formula Bar
Cell
Template
A cell that has a dark border around it.
Jail Cell
Sleepy Cell
Active Cell
Stem Cell
Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.
PO Box
Cell Reference
Status Bar
Formula Bar
The horizontal and vertical lines on the spreadsheet that identify each cell on the spreadsheet are known as the _____.
Cell Blocks
Scroll Bars
Mapping LInes
Grid-lines
A selection of two or more cells is known as a ____.
Cluster
Range
Conglomorate
Big mess
A ____ is another name for an equation used in Excel.
Formula
Calculation
Mode Indicator
Template
Every Excel formula/equation must begin with _____.
an equal sign
please and thank you
cell reference
a prayer
The ____ performs the arithmetic calculations in a formula.
Calculator
Grid-lines
Status Bar
Operator
Numerical data entered into the spreadsheet cells will appear _____ according to place-value.
Magically
Right Aligned
Left Aligned
Centered
Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.
Status Bar
Scroll Bar
Outside Window
Formula Bar
The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.
Scroll Box
Fill Handle
Cell Reference
Ribbon Tab
The contents of a worksheet will print across the length of the page in ____ ____.
Landscape Orientaion
Portrait Orientation
7th grade Orientation
Total Disorientation
The contents of a worksheet will print across the width of the page in ____ ____.
Landscape Orientaion
Portrait Orientation
7th grade Orientation
Total Disorientation
If you want to compare parts to the whole, which type of graph/chart would work the best?
Pie
Bar
Column
Line
Which of these will you find on the AutoSum dropdown menu?
All of them
MUL
DIV
SUM
Which of the following is considered a range in Excel?
9B:30C
A1:B8
A1, C22, D14
They are all ranges
Clicking this icon after selecting the range, will result in all selected cells merging into one larger cell.
Merge and Center
Center
Wrap Text
FlashFill
What is the address of this cell?
B3
3B
AB3
None of them is correct
Where do your formulas appear when you type them in a worksheet?
Name Box
Formula Bar
Search Box
Function Bar
If you can't see the Ruler, select the ______________________ tab, then click the check box next to the Ruler.
Home
Layout
View
Insert
Backstage is accessed by clicking which tab?
File
Home
Insert
View
What does the I button do?
Make text thicker
Underline text
Move the text to the bottom corner of a line
Make the text slant or lean to one side
Heading 1, Emphasis, and Title are all types of
Styles
Text Effects
Character Formats
Themes
This icon has function to....
Insert picture from our files
Insert picture from internet
Insert ready-made shapes
Function of this icon is....
to create a large capital letter at a beginning of paragraph
to choose where an image will appear on the page
to choose how your text wraps around an image
TRUE/FALSE
Insert text from another file by clicking the Insert tab, Object button, then Text from File.
TRUE
FALSE
To change document properties, like add an author, you should: _________.
Click on the Layout tab then the Change Properties button
Click on the File tab, then on Info
Click on the Developer tab and then the Edit button
Click on the File tab and then Options
To protect the document with a password, you should go Backstage and then click on: __________
About
Advanced
Info
Options
The Tab used to Create/Insert a Table into Word.
Insert Tab
Design Tab
Layout Tab
The Tab to use to Insert Rows and Columns above and below and to insert columns on the left and right
Insert Tab
Layout Tab
Design Tab
Home Tab
Allows you to sort text from Z to A or largest to smallest
Split Sort
Ascending Sort
Descending Sort
Merge Sort
The Tab to use to change Table Styles, Shading, and Borders
Home Tab
Insert Tab
LayoutTab
Design Tab
The feature that combines or joins cells together in a table.
Split Cells
Merge Cells
Distribute Rows
Distribute Columns
_____________________ is a presentation software.
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Paint
_____________________ is the method of arranging things or objects on a slide.
Layout
Object
Smart Lookup
Comments
______________ is the shortcut to paste an object.
Ctrl + C
Ctrl + X
Ctrl + S
Ctrl + V
__________________ key is used to end the slide show.
Ctrl
Shift
Esc
Alt
The ___________________ view is used to hide or show the text levels in PowerPoint presentation.
Slide Sorter
Outline
Slide Show
Reading View
A ________________ is a type of note that can be added to a text, object or to an entire slide of PowerPoint presentation.
View
Comment
Smart Lookup
Photo Album
_____________________ view allows all the slides in the presentation at the same time, in miniature form.
Reading
Slide Show
Slide Sorter
Outline
___________________ key combination takes us to the beginning of the presentation.
Page Up
Page Down
Ctrl + End
Ctrl + Home
__________________ option collapses the entire data of each slide to the slide's Title, making our work easier.
Demote
Collapse
Promote
Expand
______________________ is the shortcut key to start the slide show.
F1
F3
F5
F7
_____________, _______________, ________________ and _____________ are the four available office themes in MS PowerPoint.
Colourful, white, black, dark gray
Red, green, white, blue
Gray, white, black, brown
Colourful, white, black, red
The Apply Design Template command is used to:
Change the order of the slides
Change the shape of the slides
Change the background and fonts of the entire presentation.
Create a new, empty presentation.
You can re-arrange slides in:
Slide view
Sorter view
Notes Page View
Slide Show View
Using a custom animation effect, how do you make text appear on a slide letter by letter?
Apply the animation scheme Fade in one by one.
Apply an entrance effect, and then set it to By letter in the Effect Options dialog box.
Apply the Fly In entrance effect to the text, and then set its speed to Very Slow.
In outline view you can:
Move slides
Edit slides
Create a new slide
All of above
Holly created a membership presentation in the most current version of PowerPoint. She wants to make sure that all features of her presentation will be visible in older versions of the software. Which specific feature would she use?
check for compatibility
check for accessibility
Owen wants to look for hidden properties and personal information in a presentation that he created. Which feature would he use?
inspect the document
check for issues
Garrett is sending his presentation to the national FBLA office and wants to ensure its integrity. What feature should he use in his presentation?
Add a Digital Signature
Mark as Final
The relationship of width to height in a picture, shape, or slide
Aspect Ratio
Orientation
Custom Show
Ink
Refers to the number of pixels that makes up a slide display on the monitor and is applicable only in Slide Show view
Resolution
Slide Size
Landscape Orientation
Portrait Orientation
Mrs. Thomas, FBLA state adviser, wants to remove hidden properties and personal information in a PowerPoint she is sending. Which feature should she use?
Check for Issues
Check for Accessibility
Check for Compatibility
Inspect the Document
