Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Antoinettes workbook has all the data entered and students current grades displayed. She would like the current grade cells to display the value in red

Antoinettes workbook has all the data entered and students current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell. *

Ahighlighting

Bfill color

Ccell formatting

Dconditional formatting

In conditional formatting, to highlight only cells that contain a specific date, select the rule _____. *

AA Date Occurring

BDuplicate Values

CEqual To

DText That Contains

An Excel formula always begins with a(n) ____. *

Aplus sign

Bparentheses

Cequals sign

Dcolon

The formula used to multiply cell A1 by cell C1 is ____. *

AA1*C1

BC1*A1

C=A1*C1

D=A1/C1

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell. *

AAlt + E

BAlt + Enter

CCtrl + Enter

DCtrl + E

What is the syntax for a SUM formula adding the values of cell F6 to F9? *

A/SUM(F9:F6)

B=SUM(F6:F9)

C=END(F6:F9)

D=SUM(F6/F9)

Italic, bold, bold italic, and underline are examples of _____. *

Acharacter settings

Bgraphics

Cfont themes

Dfont styles

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probabilistic Databases

Authors: Dan Suciu, Dan Olteanu, Christopher Re, Christoph Koch

1st Edition

3031007514, 978-3031007514

More Books

Students also viewed these Databases questions

Question

=+What kinds of problems need to be overcome?

Answered: 1 week ago

Question

=+Describe an important trade-off you recently faced

Answered: 1 week ago