Exam (elaborations)
Computer Science S3 and S4 Review Questions and Answers
- Course
- Institution
Computer Science S3 and S4 Review Questions and Answers
[Show more]
Content preview
Computer Science S3 and S4 ReviewQuestions and Answers
In a conditional function like SUMIF, which item refers to where the condition is located?
- ANSWER-Range
In addition to the AutoSum feature, users can simply type the SUM function into Excel. -
ANSWER-True
The COUNT function can only count which item in Excel? - ANSWER-Numbers
The IF function can be found in which area of Excel? - ANSWER-The Logical drop-
down menu under Formulas Tab.
Users can add a total row to a table using which tab in Excel? - ANSWER-Design
Users can clear any filters on a table in Excel by using which tab? - ANSWER-Data
When sorting information inside of a table on multiple columns, it is important to sort the
most
detailed column first. - ANSWER-True
Where on the ribbon is the COUNTIF function located in Excel? - ANSWER-The
Statistical group under the More Functions drop-down menu.
Which are configuration options for table style in Excel? Pick 3 - ANSWER--First
Column
-Banded Rows
Header Row
Which best defines the CONCAT function? - ANSWER-Taking two pieces of text and
combining them.
Which is a sign that a user is working inside a table in Excel? - ANSWER-The design
tab will be visible.
Which is a true statement concerning basic formulas in Excel? - ANSWER-The user
does not need to alter the formulas when entering new data into the
applicable cells.
Which is a true statement concerning duplicate record removal in Excel? - ANSWER-
Excel will delete the bottommost duplicate record.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller CLOUND. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75759 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now