What are Word Styles and Templates used for?

They are used to apply consistent formatting and structure to documents.

They are used to create new fonts for documents.

They are used to encrypt documents for security.

They are used to check spelling and grammar only.

What is the purpose of Margins and Headers/Footers in Word?

They define the space around the text and add information at the top or bottom of each page.

They change the font style and size of the text.

They insert images and tables into the document.

They automatically correct spelling and grammar mistakes.

What is the difference between block and modified-block letter format?

In block format, all text is left-aligned; in modified-block, some elements are indented or centered.

Block format uses double spacing, while modified-block uses single spacing.

Block format is only used for informal letters, modified-block for formal letters.

Block format requires a signature, modified-block does not.

Which function do tab stops serve in a Word document?

They help position text precisely at set locations across the page.

They are used to change the color of the text.

They allow you to add tables to your document.

They are used to print the document.

What does the Track Changes feature do in Word?

It allows users to see edits and comments made to a document.

It automatically saves the document every minute.

It converts the document to PDF format.

It checks the document for viruses.

What does line spacing control in Word?

Line spacing controls the amount of space between lines of text.

Line spacing changes the font style of the text.

Line spacing adjusts the margin size of the document.

Line spacing sets the page orientation.

What is the Format Painter used for in Word?

Format Painter copies formatting from one part of a document to another.

Format Painter is used to insert images into a document.

Format Painter checks the spelling and grammar in a document.

Format Painter saves the document automatically.

What is the purpose of a table of contents with dot leaders in Word?

It helps organize document sections and guides readers to page numbers.

It automatically corrects spelling errors in the document.

It adds decorative borders to each page of the document.

It converts the document into a PDF file.

To insert a bar chart from selected data, which of the following steps should you follow?

Select the data, go to the Insert tab, and choose Bar Chart.

Select the data, go to the Home tab, and choose Bar Chart.

Select the data, go to the Review tab, and choose Bar Chart.

Select the data, go to the File tab, and choose Bar Chart.

The AutoFit feature does which of the following?

Automatically adjusts the size of cells to fit content

Why might you want to lock certain cells in an Excel worksheet?

To stop others from editing important data

Which of the following actions allows you to change the name of a worksheet?

Right-clicking the worksheet tab and selecting 'Rename'

Clicking the worksheet tab and pressing Delete

Going to the 'Insert' menu and choosing 'Worksheet'

Pressing Ctrl + V on the worksheet tab

Block style in a business letter is defined as:

A format where all text is left-aligned and paragraphs are not indented.

A format where paragraphs are indented and text is centered.

A format where the date and closing are right-aligned.

A format where the address is written at the bottom of the letter.

The benefit of using Word Styles is:

It allows for consistent formatting and easy document navigation

To insert a dynamic date that updates itself, you should:

Use a formula or function like =TODAY() or =NOW().

Use the 'Insert Date' feature and select a static date.

Copy and paste the date from another document.

What is the main function of a Primary Key in a database table?

To ensure each row in the table is unique.

To allow multiple records with the same value.

To automatically back up the table data.

To arrange records in numerical order.

Why is it important to enforce referential integrity in a relational database?

It prevents invalid data from being entered into related tables, maintaining data consistency.

It allows users to access the database without authentication, improving usability.

It compresses data to save storage space, making the database more efficient.

It automatically generates reports, simplifying data analysis.

What is the correct way to highlight cells with values less than $100 using conditional formatting?

By selecting the range, choosing Conditional Formatting, and setting the rule to 'Less than $100'

By manually coloring each cell under $100

By hiding all values above $100

By increasing the row height for all cells

To add a header that appears on every page, you should:

Insert a header from the Insert menu

Type the header at the top of each page manually

When preparing a 15 minute talk on technology in education, Daniel should take into account __________ about his audience before drafting his presentation.

Age, education level, group size and familiarity with the subject

Gender, personality, group size and interests

Education level, age, group size and hobbies

Experience level, gender, group size and occupation

What is the biggest problem with this slide?

The colors make it hard to read

A speaker's response to an audiences' question should respond by...

answering the audience's questions clearly and completely at the appropriate time.

telling the audience to "shut up!"

telling the audience "I'm organized."

answering the audience's questions with a soft tone.

What is the main advantage of using a table of contents in a long document?

It helps readers quickly locate specific sections or topics.

It automatically saves the document.

It adds images to the document.

It changes the font size of all headings.

In Excel, what does the Fill Handle allow you to do?

Copy formulas or data to adjacent cells automatically.

Protect the entire workbook from editing.

Change the color of the worksheet tab.

BIM 1 Spring 25 Review

Authored by Richard Essien

Business

9th Grade

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

40 questions

Show all answers

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

How does using a dollar sign ($) in a cell reference affect formulas in Excel?

It makes the reference absolute, so it does not change when copied to another cell.

It makes the reference relative, so it always changes when copied.

It removes the reference from the formula.

It highlights the cell in yellow.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

How can you use the Fill Handle in Excel?

To automatically continue a series, such as numbers or days, into adjacent cells.

To merge multiple cells into one cell.

To apply conditional formatting to selected cells.

To delete the contents of selected cells.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

Name two types of sheet views in Excel.

Normal and Page Layout.

Grid and Chart.

Formula and Data.

Header and Footer.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

What is Conditional Formatting used for in Excel?

Conditional Formatting is used to highlight cells based on specific rules.

Conditional Formatting is used to sort data alphabetically.

Conditional Formatting is used to create charts automatically.

Conditional Formatting is used to protect worksheets from editing.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

Name two types of charts you can insert in Excel.

Bar chart and Pie chart.

Text chart and Image chart.

Sound chart and Video chart.

Shape chart and Color chart.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

What does the AutoFit feature do in Excel?

AutoFit automatically adjusts the width or height of a cell to fit its contents.

AutoFit deletes empty rows and columns in a worksheet.

AutoFit merges multiple cells into one cell.

AutoFit applies a filter to the selected data.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

How can you protect formulas in Excel?

By locking formulas and protecting cells.

By changing the font color to white.

By saving the file as a PDF.

By hiding the worksheet tabs.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

38 questions

FBLA Economics

Quiz

•

9th - 12th Grade

41 questions

JSC, Cooperative society and Public Sector

Quiz

•

9th Grade

40 questions

Business Essentials 2.01 - 2.02 Review

Quiz

•

9th - 12th Grade

37 questions

Saving (B10)

Quiz

•

9th - 12th Grade

36 questions

TestOut Chapter 1 (minus section 1.4)

Quiz

•

9th - 12th Grade

38 questions

UNIT 9 Ticket Sales Test Review

Quiz

•

9th Grade

39 questions

Accounting Part 1 Review

Quiz

•

9th - 12th Grade

40 questions

ESB- Domain 1: Entrepreneurial and Small Business Concepts

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

22 questions

School Wide Vocab Group 1 Master

Quiz

•

6th - 8th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

12 questions

What makes Nebraska's government unique?

Quiz

•

4th - 5th Grade

Discover more resources for Business

20 questions

Mastering Job Interview Skills

Quiz

•

9th Grade

48 questions

ESB Certification Review Test #2

Quiz

•

9th - 12th Grade

BIM 1 Spring 25 Review

How does using a dollar sign ($) in a cell reference affect formulas in Excel?

How can you use the Fill Handle in Excel?

Name two types of sheet views in Excel.

What is Conditional Formatting used for in Excel?

Name two types of charts you can insert in Excel.

What does the AutoFit feature do in Excel?

How can you protect formulas in Excel?

Where can you find the PivotTable option in Excel?

Which keyboard shortcut is used to insert a new worksheet in Excel?

(a)

What are Word Styles and Templates used for?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business

BIM 1 Spring 25 Review

How does using a dollar sign ($) in a cell reference affect formulas in Excel?

How can you use the Fill Handle in Excel?

Name two types of sheet views in Excel.

What is Conditional Formatting used for in Excel?

Name two types of charts you can insert in Excel.

What does the AutoFit feature do in Excel?

How can you protect formulas in Excel?

Where can you find the PivotTable option in Excel?

Which keyboard shortcut is used to insert a new worksheet in Excel? (a)

What are Word Styles and Templates used for?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business

Which keyboard shortcut is used to insert a new worksheet in Excel?

(a)